package com.ruoyi.system.Fdongbei.mapper;

import com.ruoyi.system.Fdongbei.domain.TbMenjin;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author fufeng
 * @since 2024-12-05
 */
public interface TbMenjinMapper  {

    @Select(" select count(*) from tb_menjin where ch = #{chehao} and cczt is null ")
    public int carRecordExists(String chehao);

    @Select(" select * from tb_menjin where czbh = #{czbh} ")
    public TbMenjin selectbyczbh(String czbh);

    @Delete(" delete from tb_menjin where czbh = #{czbh} ")
    int deletemenjinbyczbh(String czbh);

}
